REM  SQL scripts for Chapter 14 of ORACLE8 DBA Handbook by Kevin Loney.
REM  See www.osborne.com for updates to these scripts.

# /etc/oratab:
loc:/orasw/app/oracle/product/8.0.3.1:Y
cc1:/orasw/app/oracle/product/8.0.3.1:N
old:/orasw/app/oracle/product/8.0.3.0:Y

#tnsnames.ora:
HQ =(DESCRIPTION=
      (ADDRESS=
            (PROTOCOL=TCP)
            (HOST=HQ)
            (PORT=1521))
      (CONNECT DATA=
            (SID=loc)))

#listener.ora:
LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= loc.world)
        )
   ) 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = loc)
      (ORACLE_HOME = /orasw/app/oracle/product/8.0.3.1)
    )
  )



> lsnrctl start
> lsnrctl start my_lsnr
> lsnrctl status


> ps -ef | grep tnslsnr


> lsnrctl
LSNRCTL> set password lsnr_password
LSNRCTL> stop

> lsnrctl status

> lsnrctl status hq

> lsnrctl version

> lsnrctl
LSNRCTL> set password lsnr_password
LSNRCTL> services

> lsnrctl
LSNRCTL> set password lsnr_password
LSNRCTL> reload

> lsnrctl
LSNRCTL> set password lsnr_password
LSNRCTL> save_config

>lsnrctl
LSNRCTL> set password lsnr_password
LSNRCTL> trace user

> lsnrctl
LSNRCTL> set password lsnr_password
LSNRCTL> start


> telnet host_name


> ping host_name

> lsnrctl status service_name


